Q1. Read the data as an appropriate Time Series data and plot the data.

Q2. Perform appropriate Exploratory Data Analysis to understand the data and also perform decomposition.

Q3.Split the data into training and test. The test data should start in 1991.

Q4). Build various exponential smoothing models on the training data and evaluate the model usingRMSE on the test data. Other models such as regression,naïve forecast models and simple averagemodels. should also be built on the training data and check the performance on the test data using RMSE

Model 1 : Linear Regression
Model 2: Naive
Model 3 : Simple Average
Model 4 : Moving Average
Model 5: Simple Exponential Smoothing
Model 7: Triple Exponential Smoothing

5. Check for the stationarity of the data on which the model is being built on using appropriate statistical tests and also mention the hypothesis for the statistical test. If the data is found to be non-stationary, take appropriate steps to make it stationary. Check the new data for stationarity and comment. Note: Stationarity should be checked at alpha = 0.05.

6. Build an automated version of the ARIMA/SARIMA model in which the parameters are selected using the lowest Akaike Information Criteria (AIC) on the training data and evaluate this model on the test data using RMSE.

7. Build ARIMA/SARIMA models based on the cut-off points of ACF and PACF on the training data and evaluate this model on the test data using RMSE.

8. Build a table (create a data frame) with all the models built along with their corresponding parameters and the respective RMSE values on the test data.

9. Based on the model-building exercise, build the most optimum model(s) on the complete data and predict 12 months into the future with appropriate confidence intervals/bands.

Sparkling wine sales